/*
*
* FrameworkContractGoodsInfoExample.java
* @author may
* @date 2021-04-06 22:28:45
*/
package com.steel.yfmall.cloud.assistant.po.goods;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class FrameworkContractGoodsInfoExample {
    /**
     * framework_contract_goods_info
     */
    protected String orderByClause;

    /**
     * framework_contract_goods_info
     */
    protected boolean distinct;

    /**
     * framework_contract_goods_info
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:framework_contract_goods_info
     * @Title: FrameworkContractGoodsInfoExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-04-06 22:28:45
     */
    public FrameworkContractGoodsInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:framework_contract_goods_info
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-04-06 22:28:45
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:framework_contract_goods_info
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-04-06 22:28:45
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:framework_contract_goods_info
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-04-06 22:28:45
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:framework_contract_goods_info
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-04-06 22:28:45
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:framework_contract_goods_info
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-04-06 22:28:45
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:framework_contract_goods_info
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-04-06 22:28:45
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:framework_contract_goods_info
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-04-06 22:28:45
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:framework_contract_goods_info
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-04-06 22:28:45
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:framework_contract_goods_info
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-04-06 22:28:45
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:framework_contract_goods_info
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-04-06 22:28:45
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title framework_contract_goods_info表的实体类
     * @description framework_contract_goods_info
     * @version 1.0
     * @author may
     * @date 2021-04-06 22:28:45
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoIsNull() {
            addCriterion("commerce_contract_no is null");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoIsNotNull() {
            addCriterion("commerce_contract_no is not null");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoEqualTo(String value) {
            addCriterion("commerce_contract_no =", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotEqualTo(String value) {
            addCriterion("commerce_contract_no <>", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoGreaterThan(String value) {
            addCriterion("commerce_contract_no >", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("commerce_contract_no >=", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoLessThan(String value) {
            addCriterion("commerce_contract_no <", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoLessThanOrEqualTo(String value) {
            addCriterion("commerce_contract_no <=", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoLike(String value) {
            addCriterion("commerce_contract_no like", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotLike(String value) {
            addCriterion("commerce_contract_no not like", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoIn(List<String> values) {
            addCriterion("commerce_contract_no in", values, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotIn(List<String> values) {
            addCriterion("commerce_contract_no not in", values, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoBetween(String value1, String value2) {
            addCriterion("commerce_contract_no between", value1, value2, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotBetween(String value1, String value2) {
            addCriterion("commerce_contract_no not between", value1, value2, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andContractItemIsNull() {
            addCriterion("contract_item is null");
            return (Criteria) this;
        }

        public Criteria andContractItemIsNotNull() {
            addCriterion("contract_item is not null");
            return (Criteria) this;
        }

        public Criteria andContractItemEqualTo(Integer value) {
            addCriterion("contract_item =", value, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemNotEqualTo(Integer value) {
            addCriterion("contract_item <>", value, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemGreaterThan(Integer value) {
            addCriterion("contract_item >", value, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemGreaterThanOrEqualTo(Integer value) {
            addCriterion("contract_item >=", value, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemLessThan(Integer value) {
            addCriterion("contract_item <", value, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemLessThanOrEqualTo(Integer value) {
            addCriterion("contract_item <=", value, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemIn(List<Integer> values) {
            addCriterion("contract_item in", values, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemNotIn(List<Integer> values) {
            addCriterion("contract_item not in", values, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemBetween(Integer value1, Integer value2) {
            addCriterion("contract_item between", value1, value2, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractItemNotBetween(Integer value1, Integer value2) {
            addCriterion("contract_item not between", value1, value2, "contractItem");
            return (Criteria) this;
        }

        public Criteria andContractVerIsNull() {
            addCriterion("contract_ver is null");
            return (Criteria) this;
        }

        public Criteria andContractVerIsNotNull() {
            addCriterion("contract_ver is not null");
            return (Criteria) this;
        }

        public Criteria andContractVerEqualTo(String value) {
            addCriterion("contract_ver =", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotEqualTo(String value) {
            addCriterion("contract_ver <>", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerGreaterThan(String value) {
            addCriterion("contract_ver >", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerGreaterThanOrEqualTo(String value) {
            addCriterion("contract_ver >=", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerLessThan(String value) {
            addCriterion("contract_ver <", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerLessThanOrEqualTo(String value) {
            addCriterion("contract_ver <=", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerLike(String value) {
            addCriterion("contract_ver like", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotLike(String value) {
            addCriterion("contract_ver not like", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerIn(List<String> values) {
            addCriterion("contract_ver in", values, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotIn(List<String> values) {
            addCriterion("contract_ver not in", values, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerBetween(String value1, String value2) {
            addCriterion("contract_ver between", value1, value2, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotBetween(String value1, String value2) {
            addCriterion("contract_ver not between", value1, value2, "contractVer");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNull() {
            addCriterion("delivery_date is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNotNull() {
            addCriterion("delivery_date is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateEqualTo(Date value) {
            addCriterionForJDBCDate("delivery_date =", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("delivery_date <>", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThan(Date value) {
            addCriterionForJDBCDate("delivery_date >", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("delivery_date >=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThan(Date value) {
            addCriterionForJDBCDate("delivery_date <", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("delivery_date <=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIn(List<Date> values) {
            addCriterionForJDBCDate("delivery_date in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("delivery_date not in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("delivery_date between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("delivery_date not between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNull() {
            addCriterion("category_id is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNotNull() {
            addCriterion("category_id is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdEqualTo(String value) {
            addCriterion("category_id =", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotEqualTo(String value) {
            addCriterion("category_id <>", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThan(String value) {
            addCriterion("category_id >", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanOrEqualTo(String value) {
            addCriterion("category_id >=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThan(String value) {
            addCriterion("category_id <", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanOrEqualTo(String value) {
            addCriterion("category_id <=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLike(String value) {
            addCriterion("category_id like", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotLike(String value) {
            addCriterion("category_id not like", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIn(List<String> values) {
            addCriterion("category_id in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotIn(List<String> values) {
            addCriterion("category_id not in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdBetween(String value1, String value2) {
            addCriterion("category_id between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotBetween(String value1, String value2) {
            addCriterion("category_id not between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andPsrNoIsNull() {
            addCriterion("psr_no is null");
            return (Criteria) this;
        }

        public Criteria andPsrNoIsNotNull() {
            addCriterion("psr_no is not null");
            return (Criteria) this;
        }

        public Criteria andPsrNoEqualTo(String value) {
            addCriterion("psr_no =", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotEqualTo(String value) {
            addCriterion("psr_no <>", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoGreaterThan(String value) {
            addCriterion("psr_no >", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoGreaterThanOrEqualTo(String value) {
            addCriterion("psr_no >=", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLessThan(String value) {
            addCriterion("psr_no <", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLessThanOrEqualTo(String value) {
            addCriterion("psr_no <=", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLike(String value) {
            addCriterion("psr_no like", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotLike(String value) {
            addCriterion("psr_no not like", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoIn(List<String> values) {
            addCriterion("psr_no in", values, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotIn(List<String> values) {
            addCriterion("psr_no not in", values, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoBetween(String value1, String value2) {
            addCriterion("psr_no between", value1, value2, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotBetween(String value1, String value2) {
            addCriterion("psr_no not between", value1, value2, "psrNo");
            return (Criteria) this;
        }

        public Criteria andApnNoIsNull() {
            addCriterion("apn_no is null");
            return (Criteria) this;
        }

        public Criteria andApnNoIsNotNull() {
            addCriterion("apn_no is not null");
            return (Criteria) this;
        }

        public Criteria andApnNoEqualTo(String value) {
            addCriterion("apn_no =", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoNotEqualTo(String value) {
            addCriterion("apn_no <>", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoGreaterThan(String value) {
            addCriterion("apn_no >", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoGreaterThanOrEqualTo(String value) {
            addCriterion("apn_no >=", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoLessThan(String value) {
            addCriterion("apn_no <", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoLessThanOrEqualTo(String value) {
            addCriterion("apn_no <=", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoLike(String value) {
            addCriterion("apn_no like", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoNotLike(String value) {
            addCriterion("apn_no not like", value, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoIn(List<String> values) {
            addCriterion("apn_no in", values, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoNotIn(List<String> values) {
            addCriterion("apn_no not in", values, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoBetween(String value1, String value2) {
            addCriterion("apn_no between", value1, value2, "apnNo");
            return (Criteria) this;
        }

        public Criteria andApnNoNotBetween(String value1, String value2) {
            addCriterion("apn_no not between", value1, value2, "apnNo");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNull() {
            addCriterion("material is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNotNull() {
            addCriterion("material is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialEqualTo(String value) {
            addCriterion("material =", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotEqualTo(String value) {
            addCriterion("material <>", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThan(String value) {
            addCriterion("material >", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("material >=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThan(String value) {
            addCriterion("material <", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThanOrEqualTo(String value) {
            addCriterion("material <=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLike(String value) {
            addCriterion("material like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotLike(String value) {
            addCriterion("material not like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialIn(List<String> values) {
            addCriterion("material in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotIn(List<String> values) {
            addCriterion("material not in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialBetween(String value1, String value2) {
            addCriterion("material between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotBetween(String value1, String value2) {
            addCriterion("material not between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andQualityIsNull() {
            addCriterion("quality is null");
            return (Criteria) this;
        }

        public Criteria andQualityIsNotNull() {
            addCriterion("quality is not null");
            return (Criteria) this;
        }

        public Criteria andQualityEqualTo(String value) {
            addCriterion("quality =", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityNotEqualTo(String value) {
            addCriterion("quality <>", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityGreaterThan(String value) {
            addCriterion("quality >", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityGreaterThanOrEqualTo(String value) {
            addCriterion("quality >=", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityLessThan(String value) {
            addCriterion("quality <", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityLessThanOrEqualTo(String value) {
            addCriterion("quality <=", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityLike(String value) {
            addCriterion("quality like", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityNotLike(String value) {
            addCriterion("quality not like", value, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityIn(List<String> values) {
            addCriterion("quality in", values, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityNotIn(List<String> values) {
            addCriterion("quality not in", values, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityBetween(String value1, String value2) {
            addCriterion("quality between", value1, value2, "quality");
            return (Criteria) this;
        }

        public Criteria andQualityNotBetween(String value1, String value2) {
            addCriterion("quality not between", value1, value2, "quality");
            return (Criteria) this;
        }

        public Criteria andStandNameIsNull() {
            addCriterion("stand_name is null");
            return (Criteria) this;
        }

        public Criteria andStandNameIsNotNull() {
            addCriterion("stand_name is not null");
            return (Criteria) this;
        }

        public Criteria andStandNameEqualTo(String value) {
            addCriterion("stand_name =", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotEqualTo(String value) {
            addCriterion("stand_name <>", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameGreaterThan(String value) {
            addCriterion("stand_name >", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameGreaterThanOrEqualTo(String value) {
            addCriterion("stand_name >=", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLessThan(String value) {
            addCriterion("stand_name <", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLessThanOrEqualTo(String value) {
            addCriterion("stand_name <=", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLike(String value) {
            addCriterion("stand_name like", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotLike(String value) {
            addCriterion("stand_name not like", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameIn(List<String> values) {
            addCriterion("stand_name in", values, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotIn(List<String> values) {
            addCriterion("stand_name not in", values, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameBetween(String value1, String value2) {
            addCriterion("stand_name between", value1, value2, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotBetween(String value1, String value2) {
            addCriterion("stand_name not between", value1, value2, "standName");
            return (Criteria) this;
        }

        public Criteria andMscNoIsNull() {
            addCriterion("msc_no is null");
            return (Criteria) this;
        }

        public Criteria andMscNoIsNotNull() {
            addCriterion("msc_no is not null");
            return (Criteria) this;
        }

        public Criteria andMscNoEqualTo(String value) {
            addCriterion("msc_no =", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotEqualTo(String value) {
            addCriterion("msc_no <>", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoGreaterThan(String value) {
            addCriterion("msc_no >", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoGreaterThanOrEqualTo(String value) {
            addCriterion("msc_no >=", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoLessThan(String value) {
            addCriterion("msc_no <", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoLessThanOrEqualTo(String value) {
            addCriterion("msc_no <=", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoLike(String value) {
            addCriterion("msc_no like", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotLike(String value) {
            addCriterion("msc_no not like", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoIn(List<String> values) {
            addCriterion("msc_no in", values, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotIn(List<String> values) {
            addCriterion("msc_no not in", values, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoBetween(String value1, String value2) {
            addCriterion("msc_no between", value1, value2, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotBetween(String value1, String value2) {
            addCriterion("msc_no not between", value1, value2, "mscNo");
            return (Criteria) this;
        }

        public Criteria andOrderThickIsNull() {
            addCriterion("order_thick is null");
            return (Criteria) this;
        }

        public Criteria andOrderThickIsNotNull() {
            addCriterion("order_thick is not null");
            return (Criteria) this;
        }

        public Criteria andOrderThickEqualTo(String value) {
            addCriterion("order_thick =", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickNotEqualTo(String value) {
            addCriterion("order_thick <>", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickGreaterThan(String value) {
            addCriterion("order_thick >", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickGreaterThanOrEqualTo(String value) {
            addCriterion("order_thick >=", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickLessThan(String value) {
            addCriterion("order_thick <", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickLessThanOrEqualTo(String value) {
            addCriterion("order_thick <=", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickLike(String value) {
            addCriterion("order_thick like", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickNotLike(String value) {
            addCriterion("order_thick not like", value, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickIn(List<String> values) {
            addCriterion("order_thick in", values, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickNotIn(List<String> values) {
            addCriterion("order_thick not in", values, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickBetween(String value1, String value2) {
            addCriterion("order_thick between", value1, value2, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderThickNotBetween(String value1, String value2) {
            addCriterion("order_thick not between", value1, value2, "orderThick");
            return (Criteria) this;
        }

        public Criteria andOrderWidthIsNull() {
            addCriterion("order_width is null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthIsNotNull() {
            addCriterion("order_width is not null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthEqualTo(Double value) {
            addCriterion("order_width =", value, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthNotEqualTo(Double value) {
            addCriterion("order_width <>", value, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthGreaterThan(Double value) {
            addCriterion("order_width >", value, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthGreaterThanOrEqualTo(Double value) {
            addCriterion("order_width >=", value, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthLessThan(Double value) {
            addCriterion("order_width <", value, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthLessThanOrEqualTo(Double value) {
            addCriterion("order_width <=", value, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthIn(List<Double> values) {
            addCriterion("order_width in", values, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthNotIn(List<Double> values) {
            addCriterion("order_width not in", values, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthBetween(Double value1, Double value2) {
            addCriterion("order_width between", value1, value2, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderWidthNotBetween(Double value1, Double value2) {
            addCriterion("order_width not between", value1, value2, "orderWidth");
            return (Criteria) this;
        }

        public Criteria andOrderLengthIsNull() {
            addCriterion("order_length is null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthIsNotNull() {
            addCriterion("order_length is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthEqualTo(Double value) {
            addCriterion("order_length =", value, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthNotEqualTo(Double value) {
            addCriterion("order_length <>", value, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthGreaterThan(Double value) {
            addCriterion("order_length >", value, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthGreaterThanOrEqualTo(Double value) {
            addCriterion("order_length >=", value, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthLessThan(Double value) {
            addCriterion("order_length <", value, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthLessThanOrEqualTo(Double value) {
            addCriterion("order_length <=", value, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthIn(List<Double> values) {
            addCriterion("order_length in", values, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthNotIn(List<Double> values) {
            addCriterion("order_length not in", values, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthBetween(Double value1, Double value2) {
            addCriterion("order_length between", value1, value2, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderLengthNotBetween(Double value1, Double value2) {
            addCriterion("order_length not between", value1, value2, "orderLength");
            return (Criteria) this;
        }

        public Criteria andOrderFThickIsNull() {
            addCriterion("order_f_thick is null");
            return (Criteria) this;
        }

        public Criteria andOrderFThickIsNotNull() {
            addCriterion("order_f_thick is not null");
            return (Criteria) this;
        }

        public Criteria andOrderFThickEqualTo(Double value) {
            addCriterion("order_f_thick =", value, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickNotEqualTo(Double value) {
            addCriterion("order_f_thick <>", value, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickGreaterThan(Double value) {
            addCriterion("order_f_thick >", value, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickGreaterThanOrEqualTo(Double value) {
            addCriterion("order_f_thick >=", value, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickLessThan(Double value) {
            addCriterion("order_f_thick <", value, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickLessThanOrEqualTo(Double value) {
            addCriterion("order_f_thick <=", value, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickIn(List<Double> values) {
            addCriterion("order_f_thick in", values, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickNotIn(List<Double> values) {
            addCriterion("order_f_thick not in", values, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickBetween(Double value1, Double value2) {
            addCriterion("order_f_thick between", value1, value2, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFThickNotBetween(Double value1, Double value2) {
            addCriterion("order_f_thick not between", value1, value2, "orderFThick");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthIsNull() {
            addCriterion("order_f_width is null");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthIsNotNull() {
            addCriterion("order_f_width is not null");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthEqualTo(Double value) {
            addCriterion("order_f_width =", value, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthNotEqualTo(Double value) {
            addCriterion("order_f_width <>", value, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthGreaterThan(Double value) {
            addCriterion("order_f_width >", value, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthGreaterThanOrEqualTo(Double value) {
            addCriterion("order_f_width >=", value, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthLessThan(Double value) {
            addCriterion("order_f_width <", value, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthLessThanOrEqualTo(Double value) {
            addCriterion("order_f_width <=", value, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthIn(List<Double> values) {
            addCriterion("order_f_width in", values, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthNotIn(List<Double> values) {
            addCriterion("order_f_width not in", values, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthBetween(Double value1, Double value2) {
            addCriterion("order_f_width between", value1, value2, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFWidthNotBetween(Double value1, Double value2) {
            addCriterion("order_f_width not between", value1, value2, "orderFWidth");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthIsNull() {
            addCriterion("order_f_length is null");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthIsNotNull() {
            addCriterion("order_f_length is not null");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthEqualTo(Double value) {
            addCriterion("order_f_length =", value, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthNotEqualTo(Double value) {
            addCriterion("order_f_length <>", value, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthGreaterThan(Double value) {
            addCriterion("order_f_length >", value, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthGreaterThanOrEqualTo(Double value) {
            addCriterion("order_f_length >=", value, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthLessThan(Double value) {
            addCriterion("order_f_length <", value, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthLessThanOrEqualTo(Double value) {
            addCriterion("order_f_length <=", value, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthIn(List<Double> values) {
            addCriterion("order_f_length in", values, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthNotIn(List<Double> values) {
            addCriterion("order_f_length not in", values, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthBetween(Double value1, Double value2) {
            addCriterion("order_f_length between", value1, value2, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderFLengthNotBetween(Double value1, Double value2) {
            addCriterion("order_f_length not between", value1, value2, "orderFLength");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaIsNull() {
            addCriterion("order_outer_dia is null");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaIsNotNull() {
            addCriterion("order_outer_dia is not null");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaEqualTo(Double value) {
            addCriterion("order_outer_dia =", value, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaNotEqualTo(Double value) {
            addCriterion("order_outer_dia <>", value, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaGreaterThan(Double value) {
            addCriterion("order_outer_dia >", value, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaGreaterThanOrEqualTo(Double value) {
            addCriterion("order_outer_dia >=", value, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaLessThan(Double value) {
            addCriterion("order_outer_dia <", value, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaLessThanOrEqualTo(Double value) {
            addCriterion("order_outer_dia <=", value, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaIn(List<Double> values) {
            addCriterion("order_outer_dia in", values, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaNotIn(List<Double> values) {
            addCriterion("order_outer_dia not in", values, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaBetween(Double value1, Double value2) {
            addCriterion("order_outer_dia between", value1, value2, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderOuterDiaNotBetween(Double value1, Double value2) {
            addCriterion("order_outer_dia not between", value1, value2, "orderOuterDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaIsNull() {
            addCriterion("order_inner_dia is null");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaIsNotNull() {
            addCriterion("order_inner_dia is not null");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaEqualTo(Double value) {
            addCriterion("order_inner_dia =", value, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaNotEqualTo(Double value) {
            addCriterion("order_inner_dia <>", value, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaGreaterThan(Double value) {
            addCriterion("order_inner_dia >", value, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaGreaterThanOrEqualTo(Double value) {
            addCriterion("order_inner_dia >=", value, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaLessThan(Double value) {
            addCriterion("order_inner_dia <", value, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaLessThanOrEqualTo(Double value) {
            addCriterion("order_inner_dia <=", value, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaIn(List<Double> values) {
            addCriterion("order_inner_dia in", values, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaNotIn(List<Double> values) {
            addCriterion("order_inner_dia not in", values, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaBetween(Double value1, Double value2) {
            addCriterion("order_inner_dia between", value1, value2, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderInnerDiaNotBetween(Double value1, Double value2) {
            addCriterion("order_inner_dia not between", value1, value2, "orderInnerDia");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinIsNull() {
            addCriterion("order_thick_min is null");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinIsNotNull() {
            addCriterion("order_thick_min is not null");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinEqualTo(Double value) {
            addCriterion("order_thick_min =", value, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinNotEqualTo(Double value) {
            addCriterion("order_thick_min <>", value, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinGreaterThan(Double value) {
            addCriterion("order_thick_min >", value, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinGreaterThanOrEqualTo(Double value) {
            addCriterion("order_thick_min >=", value, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinLessThan(Double value) {
            addCriterion("order_thick_min <", value, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinLessThanOrEqualTo(Double value) {
            addCriterion("order_thick_min <=", value, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinIn(List<Double> values) {
            addCriterion("order_thick_min in", values, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinNotIn(List<Double> values) {
            addCriterion("order_thick_min not in", values, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinBetween(Double value1, Double value2) {
            addCriterion("order_thick_min between", value1, value2, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMinNotBetween(Double value1, Double value2) {
            addCriterion("order_thick_min not between", value1, value2, "orderThickMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxIsNull() {
            addCriterion("order_thick_max is null");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxIsNotNull() {
            addCriterion("order_thick_max is not null");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxEqualTo(Double value) {
            addCriterion("order_thick_max =", value, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxNotEqualTo(Double value) {
            addCriterion("order_thick_max <>", value, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxGreaterThan(Double value) {
            addCriterion("order_thick_max >", value, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxGreaterThanOrEqualTo(Double value) {
            addCriterion("order_thick_max >=", value, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxLessThan(Double value) {
            addCriterion("order_thick_max <", value, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxLessThanOrEqualTo(Double value) {
            addCriterion("order_thick_max <=", value, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxIn(List<Double> values) {
            addCriterion("order_thick_max in", values, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxNotIn(List<Double> values) {
            addCriterion("order_thick_max not in", values, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxBetween(Double value1, Double value2) {
            addCriterion("order_thick_max between", value1, value2, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderThickMaxNotBetween(Double value1, Double value2) {
            addCriterion("order_thick_max not between", value1, value2, "orderThickMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxIsNull() {
            addCriterion("order_width_max is null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxIsNotNull() {
            addCriterion("order_width_max is not null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxEqualTo(Double value) {
            addCriterion("order_width_max =", value, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxNotEqualTo(Double value) {
            addCriterion("order_width_max <>", value, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxGreaterThan(Double value) {
            addCriterion("order_width_max >", value, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxGreaterThanOrEqualTo(Double value) {
            addCriterion("order_width_max >=", value, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxLessThan(Double value) {
            addCriterion("order_width_max <", value, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxLessThanOrEqualTo(Double value) {
            addCriterion("order_width_max <=", value, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxIn(List<Double> values) {
            addCriterion("order_width_max in", values, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxNotIn(List<Double> values) {
            addCriterion("order_width_max not in", values, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxBetween(Double value1, Double value2) {
            addCriterion("order_width_max between", value1, value2, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMaxNotBetween(Double value1, Double value2) {
            addCriterion("order_width_max not between", value1, value2, "orderWidthMax");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinIsNull() {
            addCriterion("order_width_min is null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinIsNotNull() {
            addCriterion("order_width_min is not null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinEqualTo(Double value) {
            addCriterion("order_width_min =", value, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinNotEqualTo(Double value) {
            addCriterion("order_width_min <>", value, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinGreaterThan(Double value) {
            addCriterion("order_width_min >", value, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinGreaterThanOrEqualTo(Double value) {
            addCriterion("order_width_min >=", value, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinLessThan(Double value) {
            addCriterion("order_width_min <", value, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinLessThanOrEqualTo(Double value) {
            addCriterion("order_width_min <=", value, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinIn(List<Double> values) {
            addCriterion("order_width_min in", values, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinNotIn(List<Double> values) {
            addCriterion("order_width_min not in", values, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinBetween(Double value1, Double value2) {
            addCriterion("order_width_min between", value1, value2, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderWidthMinNotBetween(Double value1, Double value2) {
            addCriterion("order_width_min not between", value1, value2, "orderWidthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxIsNull() {
            addCriterion("order_length_max is null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxIsNotNull() {
            addCriterion("order_length_max is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxEqualTo(Double value) {
            addCriterion("order_length_max =", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxNotEqualTo(Double value) {
            addCriterion("order_length_max <>", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxGreaterThan(Double value) {
            addCriterion("order_length_max >", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxGreaterThanOrEqualTo(Double value) {
            addCriterion("order_length_max >=", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxLessThan(Double value) {
            addCriterion("order_length_max <", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxLessThanOrEqualTo(Double value) {
            addCriterion("order_length_max <=", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxIn(List<Double> values) {
            addCriterion("order_length_max in", values, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxNotIn(List<Double> values) {
            addCriterion("order_length_max not in", values, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxBetween(Double value1, Double value2) {
            addCriterion("order_length_max between", value1, value2, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxNotBetween(Double value1, Double value2) {
            addCriterion("order_length_max not between", value1, value2, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinIsNull() {
            addCriterion("order_length_min is null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinIsNotNull() {
            addCriterion("order_length_min is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinEqualTo(Double value) {
            addCriterion("order_length_min =", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinNotEqualTo(Double value) {
            addCriterion("order_length_min <>", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinGreaterThan(Double value) {
            addCriterion("order_length_min >", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinGreaterThanOrEqualTo(Double value) {
            addCriterion("order_length_min >=", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinLessThan(Double value) {
            addCriterion("order_length_min <", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinLessThanOrEqualTo(Double value) {
            addCriterion("order_length_min <=", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinIn(List<Double> values) {
            addCriterion("order_length_min in", values, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinNotIn(List<Double> values) {
            addCriterion("order_length_min not in", values, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinBetween(Double value1, Double value2) {
            addCriterion("order_length_min between", value1, value2, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinNotBetween(Double value1, Double value2) {
            addCriterion("order_length_min not between", value1, value2, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderThickCIsNull() {
            addCriterion("order_thick_c is null");
            return (Criteria) this;
        }

        public Criteria andOrderThickCIsNotNull() {
            addCriterion("order_thick_c is not null");
            return (Criteria) this;
        }

        public Criteria andOrderThickCEqualTo(String value) {
            addCriterion("order_thick_c =", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCNotEqualTo(String value) {
            addCriterion("order_thick_c <>", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCGreaterThan(String value) {
            addCriterion("order_thick_c >", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCGreaterThanOrEqualTo(String value) {
            addCriterion("order_thick_c >=", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCLessThan(String value) {
            addCriterion("order_thick_c <", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCLessThanOrEqualTo(String value) {
            addCriterion("order_thick_c <=", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCLike(String value) {
            addCriterion("order_thick_c like", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCNotLike(String value) {
            addCriterion("order_thick_c not like", value, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCIn(List<String> values) {
            addCriterion("order_thick_c in", values, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCNotIn(List<String> values) {
            addCriterion("order_thick_c not in", values, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCBetween(String value1, String value2) {
            addCriterion("order_thick_c between", value1, value2, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderThickCNotBetween(String value1, String value2) {
            addCriterion("order_thick_c not between", value1, value2, "orderThickC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCIsNull() {
            addCriterion("order_width_c is null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCIsNotNull() {
            addCriterion("order_width_c is not null");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCEqualTo(String value) {
            addCriterion("order_width_c =", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCNotEqualTo(String value) {
            addCriterion("order_width_c <>", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCGreaterThan(String value) {
            addCriterion("order_width_c >", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCGreaterThanOrEqualTo(String value) {
            addCriterion("order_width_c >=", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCLessThan(String value) {
            addCriterion("order_width_c <", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCLessThanOrEqualTo(String value) {
            addCriterion("order_width_c <=", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCLike(String value) {
            addCriterion("order_width_c like", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCNotLike(String value) {
            addCriterion("order_width_c not like", value, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCIn(List<String> values) {
            addCriterion("order_width_c in", values, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCNotIn(List<String> values) {
            addCriterion("order_width_c not in", values, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCBetween(String value1, String value2) {
            addCriterion("order_width_c between", value1, value2, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderWidthCNotBetween(String value1, String value2) {
            addCriterion("order_width_c not between", value1, value2, "orderWidthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCIsNull() {
            addCriterion("order_length_c is null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCIsNotNull() {
            addCriterion("order_length_c is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCEqualTo(String value) {
            addCriterion("order_length_c =", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCNotEqualTo(String value) {
            addCriterion("order_length_c <>", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCGreaterThan(String value) {
            addCriterion("order_length_c >", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCGreaterThanOrEqualTo(String value) {
            addCriterion("order_length_c >=", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCLessThan(String value) {
            addCriterion("order_length_c <", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCLessThanOrEqualTo(String value) {
            addCriterion("order_length_c <=", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCLike(String value) {
            addCriterion("order_length_c like", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCNotLike(String value) {
            addCriterion("order_length_c not like", value, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCIn(List<String> values) {
            addCriterion("order_length_c in", values, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCNotIn(List<String> values) {
            addCriterion("order_length_c not in", values, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCBetween(String value1, String value2) {
            addCriterion("order_length_c between", value1, value2, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andOrderLengthCNotBetween(String value1, String value2) {
            addCriterion("order_length_c not between", value1, value2, "orderLengthC");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtIsNull() {
            addCriterion("goal_coil_wgt is null");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtIsNotNull() {
            addCriterion("goal_coil_wgt is not null");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtEqualTo(Double value) {
            addCriterion("goal_coil_wgt =", value, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtNotEqualTo(Double value) {
            addCriterion("goal_coil_wgt <>", value, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtGreaterThan(Double value) {
            addCriterion("goal_coil_wgt >", value, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtGreaterThanOrEqualTo(Double value) {
            addCriterion("goal_coil_wgt >=", value, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtLessThan(Double value) {
            addCriterion("goal_coil_wgt <", value, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtLessThanOrEqualTo(Double value) {
            addCriterion("goal_coil_wgt <=", value, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtIn(List<Double> values) {
            addCriterion("goal_coil_wgt in", values, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtNotIn(List<Double> values) {
            addCriterion("goal_coil_wgt not in", values, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtBetween(Double value1, Double value2) {
            addCriterion("goal_coil_wgt between", value1, value2, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andGoalCoilWgtNotBetween(Double value1, Double value2) {
            addCriterion("goal_coil_wgt not between", value1, value2, "goalCoilWgt");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinIsNull() {
            addCriterion("coil_wgt_min is null");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinIsNotNull() {
            addCriterion("coil_wgt_min is not null");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinEqualTo(Double value) {
            addCriterion("coil_wgt_min =", value, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinNotEqualTo(Double value) {
            addCriterion("coil_wgt_min <>", value, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinGreaterThan(Double value) {
            addCriterion("coil_wgt_min >", value, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinGreaterThanOrEqualTo(Double value) {
            addCriterion("coil_wgt_min >=", value, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinLessThan(Double value) {
            addCriterion("coil_wgt_min <", value, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinLessThanOrEqualTo(Double value) {
            addCriterion("coil_wgt_min <=", value, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinIn(List<Double> values) {
            addCriterion("coil_wgt_min in", values, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinNotIn(List<Double> values) {
            addCriterion("coil_wgt_min not in", values, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinBetween(Double value1, Double value2) {
            addCriterion("coil_wgt_min between", value1, value2, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMinNotBetween(Double value1, Double value2) {
            addCriterion("coil_wgt_min not between", value1, value2, "coilWgtMin");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxIsNull() {
            addCriterion("coil_wgt_max is null");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxIsNotNull() {
            addCriterion("coil_wgt_max is not null");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxEqualTo(Double value) {
            addCriterion("coil_wgt_max =", value, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxNotEqualTo(Double value) {
            addCriterion("coil_wgt_max <>", value, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxGreaterThan(Double value) {
            addCriterion("coil_wgt_max >", value, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxGreaterThanOrEqualTo(Double value) {
            addCriterion("coil_wgt_max >=", value, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxLessThan(Double value) {
            addCriterion("coil_wgt_max <", value, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxLessThanOrEqualTo(Double value) {
            addCriterion("coil_wgt_max <=", value, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxIn(List<Double> values) {
            addCriterion("coil_wgt_max in", values, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxNotIn(List<Double> values) {
            addCriterion("coil_wgt_max not in", values, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxBetween(Double value1, Double value2) {
            addCriterion("coil_wgt_max between", value1, value2, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andCoilWgtMaxNotBetween(Double value1, Double value2) {
            addCriterion("coil_wgt_max not between", value1, value2, "coilWgtMax");
            return (Criteria) this;
        }

        public Criteria andSaleMethodIsNull() {
            addCriterion("sale_method is null");
            return (Criteria) this;
        }

        public Criteria andSaleMethodIsNotNull() {
            addCriterion("sale_method is not null");
            return (Criteria) this;
        }

        public Criteria andSaleMethodEqualTo(String value) {
            addCriterion("sale_method =", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodNotEqualTo(String value) {
            addCriterion("sale_method <>", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodGreaterThan(String value) {
            addCriterion("sale_method >", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodGreaterThanOrEqualTo(String value) {
            addCriterion("sale_method >=", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodLessThan(String value) {
            addCriterion("sale_method <", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodLessThanOrEqualTo(String value) {
            addCriterion("sale_method <=", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodLike(String value) {
            addCriterion("sale_method like", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodNotLike(String value) {
            addCriterion("sale_method not like", value, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodIn(List<String> values) {
            addCriterion("sale_method in", values, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodNotIn(List<String> values) {
            addCriterion("sale_method not in", values, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodBetween(String value1, String value2) {
            addCriterion("sale_method between", value1, value2, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andSaleMethodNotBetween(String value1, String value2) {
            addCriterion("sale_method not between", value1, value2, "saleMethod");
            return (Criteria) this;
        }

        public Criteria andRuleInfoIsNull() {
            addCriterion("rule_info is null");
            return (Criteria) this;
        }

        public Criteria andRuleInfoIsNotNull() {
            addCriterion("rule_info is not null");
            return (Criteria) this;
        }

        public Criteria andRuleInfoEqualTo(String value) {
            addCriterion("rule_info =", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoNotEqualTo(String value) {
            addCriterion("rule_info <>", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoGreaterThan(String value) {
            addCriterion("rule_info >", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoGreaterThanOrEqualTo(String value) {
            addCriterion("rule_info >=", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoLessThan(String value) {
            addCriterion("rule_info <", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoLessThanOrEqualTo(String value) {
            addCriterion("rule_info <=", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoLike(String value) {
            addCriterion("rule_info like", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoNotLike(String value) {
            addCriterion("rule_info not like", value, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoIn(List<String> values) {
            addCriterion("rule_info in", values, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoNotIn(List<String> values) {
            addCriterion("rule_info not in", values, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoBetween(String value1, String value2) {
            addCriterion("rule_info between", value1, value2, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andRuleInfoNotBetween(String value1, String value2) {
            addCriterion("rule_info not between", value1, value2, "ruleInfo");
            return (Criteria) this;
        }

        public Criteria andPackCodeIsNull() {
            addCriterion("pack_code is null");
            return (Criteria) this;
        }

        public Criteria andPackCodeIsNotNull() {
            addCriterion("pack_code is not null");
            return (Criteria) this;
        }

        public Criteria andPackCodeEqualTo(String value) {
            addCriterion("pack_code =", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeNotEqualTo(String value) {
            addCriterion("pack_code <>", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeGreaterThan(String value) {
            addCriterion("pack_code >", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("pack_code >=", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeLessThan(String value) {
            addCriterion("pack_code <", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeLessThanOrEqualTo(String value) {
            addCriterion("pack_code <=", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeLike(String value) {
            addCriterion("pack_code like", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeNotLike(String value) {
            addCriterion("pack_code not like", value, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeIn(List<String> values) {
            addCriterion("pack_code in", values, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeNotIn(List<String> values) {
            addCriterion("pack_code not in", values, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeBetween(String value1, String value2) {
            addCriterion("pack_code between", value1, value2, "packCode");
            return (Criteria) this;
        }

        public Criteria andPackCodeNotBetween(String value1, String value2) {
            addCriterion("pack_code not between", value1, value2, "packCode");
            return (Criteria) this;
        }

        public Criteria andCraftIsNull() {
            addCriterion("craft is null");
            return (Criteria) this;
        }

        public Criteria andCraftIsNotNull() {
            addCriterion("craft is not null");
            return (Criteria) this;
        }

        public Criteria andCraftEqualTo(String value) {
            addCriterion("craft =", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftNotEqualTo(String value) {
            addCriterion("craft <>", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftGreaterThan(String value) {
            addCriterion("craft >", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftGreaterThanOrEqualTo(String value) {
            addCriterion("craft >=", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftLessThan(String value) {
            addCriterion("craft <", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftLessThanOrEqualTo(String value) {
            addCriterion("craft <=", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftLike(String value) {
            addCriterion("craft like", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftNotLike(String value) {
            addCriterion("craft not like", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftIn(List<String> values) {
            addCriterion("craft in", values, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftNotIn(List<String> values) {
            addCriterion("craft not in", values, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftBetween(String value1, String value2) {
            addCriterion("craft between", value1, value2, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftNotBetween(String value1, String value2) {
            addCriterion("craft not between", value1, value2, "craft");
            return (Criteria) this;
        }

        public Criteria andBundleQtyIsNull() {
            addCriterion("bundle_qty is null");
            return (Criteria) this;
        }

        public Criteria andBundleQtyIsNotNull() {
            addCriterion("bundle_qty is not null");
            return (Criteria) this;
        }

        public Criteria andBundleQtyEqualTo(Double value) {
            addCriterion("bundle_qty =", value, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyNotEqualTo(Double value) {
            addCriterion("bundle_qty <>", value, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyGreaterThan(Double value) {
            addCriterion("bundle_qty >", value, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyGreaterThanOrEqualTo(Double value) {
            addCriterion("bundle_qty >=", value, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyLessThan(Double value) {
            addCriterion("bundle_qty <", value, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyLessThanOrEqualTo(Double value) {
            addCriterion("bundle_qty <=", value, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyIn(List<Double> values) {
            addCriterion("bundle_qty in", values, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyNotIn(List<Double> values) {
            addCriterion("bundle_qty not in", values, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyBetween(Double value1, Double value2) {
            addCriterion("bundle_qty between", value1, value2, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andBundleQtyNotBetween(Double value1, Double value2) {
            addCriterion("bundle_qty not between", value1, value2, "bundleQty");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNull() {
            addCriterion("warehouse_no is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNotNull() {
            addCriterion("warehouse_no is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoEqualTo(String value) {
            addCriterion("warehouse_no =", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotEqualTo(String value) {
            addCriterion("warehouse_no <>", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThan(String value) {
            addCriterion("warehouse_no >", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThanOrEqualTo(String value) {
            addCriterion("warehouse_no >=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThan(String value) {
            addCriterion("warehouse_no <", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThanOrEqualTo(String value) {
            addCriterion("warehouse_no <=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLike(String value) {
            addCriterion("warehouse_no like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotLike(String value) {
            addCriterion("warehouse_no not like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIn(List<String> values) {
            addCriterion("warehouse_no in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotIn(List<String> values) {
            addCriterion("warehouse_no not in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoBetween(String value1, String value2) {
            addCriterion("warehouse_no between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotBetween(String value1, String value2) {
            addCriterion("warehouse_no not between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andRebateIsNull() {
            addCriterion("rebate is null");
            return (Criteria) this;
        }

        public Criteria andRebateIsNotNull() {
            addCriterion("rebate is not null");
            return (Criteria) this;
        }

        public Criteria andRebateEqualTo(String value) {
            addCriterion("rebate =", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotEqualTo(String value) {
            addCriterion("rebate <>", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateGreaterThan(String value) {
            addCriterion("rebate >", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateGreaterThanOrEqualTo(String value) {
            addCriterion("rebate >=", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateLessThan(String value) {
            addCriterion("rebate <", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateLessThanOrEqualTo(String value) {
            addCriterion("rebate <=", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateLike(String value) {
            addCriterion("rebate like", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotLike(String value) {
            addCriterion("rebate not like", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateIn(List<String> values) {
            addCriterion("rebate in", values, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotIn(List<String> values) {
            addCriterion("rebate not in", values, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateBetween(String value1, String value2) {
            addCriterion("rebate between", value1, value2, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotBetween(String value1, String value2) {
            addCriterion("rebate not between", value1, value2, "rebate");
            return (Criteria) this;
        }

        public Criteria andPieceWeightIsNull() {
            addCriterion("piece_weight is null");
            return (Criteria) this;
        }

        public Criteria andPieceWeightIsNotNull() {
            addCriterion("piece_weight is not null");
            return (Criteria) this;
        }

        public Criteria andPieceWeightEqualTo(BigDecimal value) {
            addCriterion("piece_weight =", value, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightNotEqualTo(BigDecimal value) {
            addCriterion("piece_weight <>", value, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightGreaterThan(BigDecimal value) {
            addCriterion("piece_weight >", value, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("piece_weight >=", value, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightLessThan(BigDecimal value) {
            addCriterion("piece_weight <", value, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("piece_weight <=", value, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightIn(List<BigDecimal> values) {
            addCriterion("piece_weight in", values, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightNotIn(List<BigDecimal> values) {
            addCriterion("piece_weight not in", values, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("piece_weight between", value1, value2, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andPieceWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("piece_weight not between", value1, value2, "pieceWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightIsNull() {
            addCriterion("order_weight is null");
            return (Criteria) this;
        }

        public Criteria andOrderWeightIsNotNull() {
            addCriterion("order_weight is not null");
            return (Criteria) this;
        }

        public Criteria andOrderWeightEqualTo(BigDecimal value) {
            addCriterion("order_weight =", value, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNotEqualTo(BigDecimal value) {
            addCriterion("order_weight <>", value, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGreaterThan(BigDecimal value) {
            addCriterion("order_weight >", value, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_weight >=", value, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightLessThan(BigDecimal value) {
            addCriterion("order_weight <", value, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_weight <=", value, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightIn(List<BigDecimal> values) {
            addCriterion("order_weight in", values, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNotIn(List<BigDecimal> values) {
            addCriterion("order_weight not in", values, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_weight between", value1, value2, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_weight not between", value1, value2, "orderWeight");
            return (Criteria) this;
        }

        public Criteria andContractQtyIsNull() {
            addCriterion("contract_qty is null");
            return (Criteria) this;
        }

        public Criteria andContractQtyIsNotNull() {
            addCriterion("contract_qty is not null");
            return (Criteria) this;
        }

        public Criteria andContractQtyEqualTo(Integer value) {
            addCriterion("contract_qty =", value, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyNotEqualTo(Integer value) {
            addCriterion("contract_qty <>", value, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyGreaterThan(Integer value) {
            addCriterion("contract_qty >", value, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyGreaterThanOrEqualTo(Integer value) {
            addCriterion("contract_qty >=", value, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyLessThan(Integer value) {
            addCriterion("contract_qty <", value, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyLessThanOrEqualTo(Integer value) {
            addCriterion("contract_qty <=", value, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyIn(List<Integer> values) {
            addCriterion("contract_qty in", values, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyNotIn(List<Integer> values) {
            addCriterion("contract_qty not in", values, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyBetween(Integer value1, Integer value2) {
            addCriterion("contract_qty between", value1, value2, "contractQty");
            return (Criteria) this;
        }

        public Criteria andContractQtyNotBetween(Integer value1, Integer value2) {
            addCriterion("contract_qty not between", value1, value2, "contractQty");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagIsNull() {
            addCriterion("special_price_flag is null");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagIsNotNull() {
            addCriterion("special_price_flag is not null");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagEqualTo(String value) {
            addCriterion("special_price_flag =", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagNotEqualTo(String value) {
            addCriterion("special_price_flag <>", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagGreaterThan(String value) {
            addCriterion("special_price_flag >", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagGreaterThanOrEqualTo(String value) {
            addCriterion("special_price_flag >=", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagLessThan(String value) {
            addCriterion("special_price_flag <", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagLessThanOrEqualTo(String value) {
            addCriterion("special_price_flag <=", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagLike(String value) {
            addCriterion("special_price_flag like", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagNotLike(String value) {
            addCriterion("special_price_flag not like", value, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagIn(List<String> values) {
            addCriterion("special_price_flag in", values, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagNotIn(List<String> values) {
            addCriterion("special_price_flag not in", values, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagBetween(String value1, String value2) {
            addCriterion("special_price_flag between", value1, value2, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andSpecialPriceFlagNotBetween(String value1, String value2) {
            addCriterion("special_price_flag not between", value1, value2, "specialPriceFlag");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIsNull() {
            addCriterion("goods_price is null");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIsNotNull() {
            addCriterion("goods_price is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceEqualTo(BigDecimal value) {
            addCriterion("goods_price =", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotEqualTo(BigDecimal value) {
            addCriterion("goods_price <>", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceGreaterThan(BigDecimal value) {
            addCriterion("goods_price >", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_price >=", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceLessThan(BigDecimal value) {
            addCriterion("goods_price <", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_price <=", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIn(List<BigDecimal> values) {
            addCriterion("goods_price in", values, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotIn(List<BigDecimal> values) {
            addCriterion("goods_price not in", values, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_price between", value1, value2, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_price not between", value1, value2, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolIsNull() {
            addCriterion("print_ship_tol is null");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolIsNotNull() {
            addCriterion("print_ship_tol is not null");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolEqualTo(String value) {
            addCriterion("print_ship_tol =", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolNotEqualTo(String value) {
            addCriterion("print_ship_tol <>", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolGreaterThan(String value) {
            addCriterion("print_ship_tol >", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolGreaterThanOrEqualTo(String value) {
            addCriterion("print_ship_tol >=", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolLessThan(String value) {
            addCriterion("print_ship_tol <", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolLessThanOrEqualTo(String value) {
            addCriterion("print_ship_tol <=", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolLike(String value) {
            addCriterion("print_ship_tol like", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolNotLike(String value) {
            addCriterion("print_ship_tol not like", value, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolIn(List<String> values) {
            addCriterion("print_ship_tol in", values, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolNotIn(List<String> values) {
            addCriterion("print_ship_tol not in", values, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolBetween(String value1, String value2) {
            addCriterion("print_ship_tol between", value1, value2, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andPrintShipTolNotBetween(String value1, String value2) {
            addCriterion("print_ship_tol not between", value1, value2, "printShipTol");
            return (Criteria) this;
        }

        public Criteria andProdPriceIsNull() {
            addCriterion("prod_price is null");
            return (Criteria) this;
        }

        public Criteria andProdPriceIsNotNull() {
            addCriterion("prod_price is not null");
            return (Criteria) this;
        }

        public Criteria andProdPriceEqualTo(BigDecimal value) {
            addCriterion("prod_price =", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceNotEqualTo(BigDecimal value) {
            addCriterion("prod_price <>", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceGreaterThan(BigDecimal value) {
            addCriterion("prod_price >", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_price >=", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceLessThan(BigDecimal value) {
            addCriterion("prod_price <", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_price <=", value, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceIn(List<BigDecimal> values) {
            addCriterion("prod_price in", values, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceNotIn(List<BigDecimal> values) {
            addCriterion("prod_price not in", values, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_price between", value1, value2, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andProdPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_price not between", value1, value2, "prodPrice");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagIsNull() {
            addCriterion("performance_flag is null");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagIsNotNull() {
            addCriterion("performance_flag is not null");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagEqualTo(String value) {
            addCriterion("performance_flag =", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotEqualTo(String value) {
            addCriterion("performance_flag <>", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagGreaterThan(String value) {
            addCriterion("performance_flag >", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagGreaterThanOrEqualTo(String value) {
            addCriterion("performance_flag >=", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagLessThan(String value) {
            addCriterion("performance_flag <", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagLessThanOrEqualTo(String value) {
            addCriterion("performance_flag <=", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagLike(String value) {
            addCriterion("performance_flag like", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotLike(String value) {
            addCriterion("performance_flag not like", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagIn(List<String> values) {
            addCriterion("performance_flag in", values, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotIn(List<String> values) {
            addCriterion("performance_flag not in", values, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagBetween(String value1, String value2) {
            addCriterion("performance_flag between", value1, value2, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotBetween(String value1, String value2) {
            addCriterion("performance_flag not between", value1, value2, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIsNull() {
            addCriterion("count_wgt_mode is null");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIsNotNull() {
            addCriterion("count_wgt_mode is not null");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeEqualTo(String value) {
            addCriterion("count_wgt_mode =", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotEqualTo(String value) {
            addCriterion("count_wgt_mode <>", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeGreaterThan(String value) {
            addCriterion("count_wgt_mode >", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeGreaterThanOrEqualTo(String value) {
            addCriterion("count_wgt_mode >=", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLessThan(String value) {
            addCriterion("count_wgt_mode <", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLessThanOrEqualTo(String value) {
            addCriterion("count_wgt_mode <=", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLike(String value) {
            addCriterion("count_wgt_mode like", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotLike(String value) {
            addCriterion("count_wgt_mode not like", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIn(List<String> values) {
            addCriterion("count_wgt_mode in", values, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotIn(List<String> values) {
            addCriterion("count_wgt_mode not in", values, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeBetween(String value1, String value2) {
            addCriterion("count_wgt_mode between", value1, value2, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotBetween(String value1, String value2) {
            addCriterion("count_wgt_mode not between", value1, value2, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeIsNull() {
            addCriterion("product_sys_code is null");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeIsNotNull() {
            addCriterion("product_sys_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeEqualTo(String value) {
            addCriterion("product_sys_code =", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotEqualTo(String value) {
            addCriterion("product_sys_code <>", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeGreaterThan(String value) {
            addCriterion("product_sys_code >", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_sys_code >=", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeLessThan(String value) {
            addCriterion("product_sys_code <", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeLessThanOrEqualTo(String value) {
            addCriterion("product_sys_code <=", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeLike(String value) {
            addCriterion("product_sys_code like", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotLike(String value) {
            addCriterion("product_sys_code not like", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeIn(List<String> values) {
            addCriterion("product_sys_code in", values, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotIn(List<String> values) {
            addCriterion("product_sys_code not in", values, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeBetween(String value1, String value2) {
            addCriterion("product_sys_code between", value1, value2, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotBetween(String value1, String value2) {
            addCriterion("product_sys_code not between", value1, value2, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyIsNull() {
            addCriterion("order_money is null");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyIsNotNull() {
            addCriterion("order_money is not null");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyEqualTo(BigDecimal value) {
            addCriterion("order_money =", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyNotEqualTo(BigDecimal value) {
            addCriterion("order_money <>", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyGreaterThan(BigDecimal value) {
            addCriterion("order_money >", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_money >=", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyLessThan(BigDecimal value) {
            addCriterion("order_money <", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_money <=", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyIn(List<BigDecimal> values) {
            addCriterion("order_money in", values, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyNotIn(List<BigDecimal> values) {
            addCriterion("order_money not in", values, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_money between", value1, value2, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_money not between", value1, value2, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andShipTolMinIsNull() {
            addCriterion("ship_tol_min is null");
            return (Criteria) this;
        }

        public Criteria andShipTolMinIsNotNull() {
            addCriterion("ship_tol_min is not null");
            return (Criteria) this;
        }

        public Criteria andShipTolMinEqualTo(String value) {
            addCriterion("ship_tol_min =", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinNotEqualTo(String value) {
            addCriterion("ship_tol_min <>", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinGreaterThan(String value) {
            addCriterion("ship_tol_min >", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinGreaterThanOrEqualTo(String value) {
            addCriterion("ship_tol_min >=", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinLessThan(String value) {
            addCriterion("ship_tol_min <", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinLessThanOrEqualTo(String value) {
            addCriterion("ship_tol_min <=", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinLike(String value) {
            addCriterion("ship_tol_min like", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinNotLike(String value) {
            addCriterion("ship_tol_min not like", value, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinIn(List<String> values) {
            addCriterion("ship_tol_min in", values, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinNotIn(List<String> values) {
            addCriterion("ship_tol_min not in", values, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinBetween(String value1, String value2) {
            addCriterion("ship_tol_min between", value1, value2, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMinNotBetween(String value1, String value2) {
            addCriterion("ship_tol_min not between", value1, value2, "shipTolMin");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxIsNull() {
            addCriterion("ship_tol_max is null");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxIsNotNull() {
            addCriterion("ship_tol_max is not null");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxEqualTo(String value) {
            addCriterion("ship_tol_max =", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxNotEqualTo(String value) {
            addCriterion("ship_tol_max <>", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxGreaterThan(String value) {
            addCriterion("ship_tol_max >", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxGreaterThanOrEqualTo(String value) {
            addCriterion("ship_tol_max >=", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxLessThan(String value) {
            addCriterion("ship_tol_max <", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxLessThanOrEqualTo(String value) {
            addCriterion("ship_tol_max <=", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxLike(String value) {
            addCriterion("ship_tol_max like", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxNotLike(String value) {
            addCriterion("ship_tol_max not like", value, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxIn(List<String> values) {
            addCriterion("ship_tol_max in", values, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxNotIn(List<String> values) {
            addCriterion("ship_tol_max not in", values, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxBetween(String value1, String value2) {
            addCriterion("ship_tol_max between", value1, value2, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andShipTolMaxNotBetween(String value1, String value2) {
            addCriterion("ship_tol_max not between", value1, value2, "shipTolMax");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeIsNull() {
            addCriterion("product_from_code is null");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeIsNotNull() {
            addCriterion("product_from_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeEqualTo(String value) {
            addCriterion("product_from_code =", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeNotEqualTo(String value) {
            addCriterion("product_from_code <>", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeGreaterThan(String value) {
            addCriterion("product_from_code >", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_from_code >=", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeLessThan(String value) {
            addCriterion("product_from_code <", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeLessThanOrEqualTo(String value) {
            addCriterion("product_from_code <=", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeLike(String value) {
            addCriterion("product_from_code like", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeNotLike(String value) {
            addCriterion("product_from_code not like", value, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeIn(List<String> values) {
            addCriterion("product_from_code in", values, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeNotIn(List<String> values) {
            addCriterion("product_from_code not in", values, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeBetween(String value1, String value2) {
            addCriterion("product_from_code between", value1, value2, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductFromCodeNotBetween(String value1, String value2) {
            addCriterion("product_from_code not between", value1, value2, "productFromCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeIsNull() {
            addCriterion("product_category_sales_code is null");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeIsNotNull() {
            addCriterion("product_category_sales_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeEqualTo(String value) {
            addCriterion("product_category_sales_code =", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeNotEqualTo(String value) {
            addCriterion("product_category_sales_code <>", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeGreaterThan(String value) {
            addCriterion("product_category_sales_code >", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_category_sales_code >=", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeLessThan(String value) {
            addCriterion("product_category_sales_code <", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeLessThanOrEqualTo(String value) {
            addCriterion("product_category_sales_code <=", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeLike(String value) {
            addCriterion("product_category_sales_code like", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeNotLike(String value) {
            addCriterion("product_category_sales_code not like", value, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeIn(List<String> values) {
            addCriterion("product_category_sales_code in", values, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeNotIn(List<String> values) {
            addCriterion("product_category_sales_code not in", values, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeBetween(String value1, String value2) {
            addCriterion("product_category_sales_code between", value1, value2, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductCategorySalesCodeNotBetween(String value1, String value2) {
            addCriterion("product_category_sales_code not between", value1, value2, "productCategorySalesCode");
            return (Criteria) this;
        }

        public Criteria andProductFormNameIsNull() {
            addCriterion("product_form_name is null");
            return (Criteria) this;
        }

        public Criteria andProductFormNameIsNotNull() {
            addCriterion("product_form_name is not null");
            return (Criteria) this;
        }

        public Criteria andProductFormNameEqualTo(String value) {
            addCriterion("product_form_name =", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameNotEqualTo(String value) {
            addCriterion("product_form_name <>", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameGreaterThan(String value) {
            addCriterion("product_form_name >", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameGreaterThanOrEqualTo(String value) {
            addCriterion("product_form_name >=", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameLessThan(String value) {
            addCriterion("product_form_name <", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameLessThanOrEqualTo(String value) {
            addCriterion("product_form_name <=", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameLike(String value) {
            addCriterion("product_form_name like", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameNotLike(String value) {
            addCriterion("product_form_name not like", value, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameIn(List<String> values) {
            addCriterion("product_form_name in", values, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameNotIn(List<String> values) {
            addCriterion("product_form_name not in", values, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameBetween(String value1, String value2) {
            addCriterion("product_form_name between", value1, value2, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductFormNameNotBetween(String value1, String value2) {
            addCriterion("product_form_name not between", value1, value2, "productFormName");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("product_id is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("product_id is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Integer value) {
            addCriterion("product_id =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Integer value) {
            addCriterion("product_id <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Integer value) {
            addCriterion("product_id >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("product_id >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Integer value) {
            addCriterion("product_id <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("product_id <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Integer> values) {
            addCriterion("product_id in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Integer> values) {
            addCriterion("product_id not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Integer value1, Integer value2) {
            addCriterion("product_id between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("product_id not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andSizePiecesIsNull() {
            addCriterion("size_pieces is null");
            return (Criteria) this;
        }

        public Criteria andSizePiecesIsNotNull() {
            addCriterion("size_pieces is not null");
            return (Criteria) this;
        }

        public Criteria andSizePiecesEqualTo(String value) {
            addCriterion("size_pieces =", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesNotEqualTo(String value) {
            addCriterion("size_pieces <>", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesGreaterThan(String value) {
            addCriterion("size_pieces >", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesGreaterThanOrEqualTo(String value) {
            addCriterion("size_pieces >=", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesLessThan(String value) {
            addCriterion("size_pieces <", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesLessThanOrEqualTo(String value) {
            addCriterion("size_pieces <=", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesLike(String value) {
            addCriterion("size_pieces like", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesNotLike(String value) {
            addCriterion("size_pieces not like", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesIn(List<String> values) {
            addCriterion("size_pieces in", values, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesNotIn(List<String> values) {
            addCriterion("size_pieces not in", values, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesBetween(String value1, String value2) {
            addCriterion("size_pieces between", value1, value2, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesNotBetween(String value1, String value2) {
            addCriterion("size_pieces not between", value1, value2, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("brand_id is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("brand_id is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(String value) {
            addCriterion("brand_id =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(String value) {
            addCriterion("brand_id <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(String value) {
            addCriterion("brand_id >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(String value) {
            addCriterion("brand_id >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(String value) {
            addCriterion("brand_id <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(String value) {
            addCriterion("brand_id <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLike(String value) {
            addCriterion("brand_id like", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotLike(String value) {
            addCriterion("brand_id not like", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<String> values) {
            addCriterion("brand_id in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<String> values) {
            addCriterion("brand_id not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(String value1, String value2) {
            addCriterion("brand_id between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(String value1, String value2) {
            addCriterion("brand_id not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andColorIsNull() {
            addCriterion("color is null");
            return (Criteria) this;
        }

        public Criteria andColorIsNotNull() {
            addCriterion("color is not null");
            return (Criteria) this;
        }

        public Criteria andColorEqualTo(String value) {
            addCriterion("color =", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotEqualTo(String value) {
            addCriterion("color <>", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThan(String value) {
            addCriterion("color >", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThanOrEqualTo(String value) {
            addCriterion("color >=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThan(String value) {
            addCriterion("color <", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThanOrEqualTo(String value) {
            addCriterion("color <=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLike(String value) {
            addCriterion("color like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotLike(String value) {
            addCriterion("color not like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorIn(List<String> values) {
            addCriterion("color in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotIn(List<String> values) {
            addCriterion("color not in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorBetween(String value1, String value2) {
            addCriterion("color between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotBetween(String value1, String value2) {
            addCriterion("color not between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeIsNull() {
            addCriterion("is_downgrade is null");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeIsNotNull() {
            addCriterion("is_downgrade is not null");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeEqualTo(String value) {
            addCriterion("is_downgrade =", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotEqualTo(String value) {
            addCriterion("is_downgrade <>", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeGreaterThan(String value) {
            addCriterion("is_downgrade >", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeGreaterThanOrEqualTo(String value) {
            addCriterion("is_downgrade >=", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeLessThan(String value) {
            addCriterion("is_downgrade <", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeLessThanOrEqualTo(String value) {
            addCriterion("is_downgrade <=", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeLike(String value) {
            addCriterion("is_downgrade like", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotLike(String value) {
            addCriterion("is_downgrade not like", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeIn(List<String> values) {
            addCriterion("is_downgrade in", values, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotIn(List<String> values) {
            addCriterion("is_downgrade not in", values, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeBetween(String value1, String value2) {
            addCriterion("is_downgrade between", value1, value2, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotBetween(String value1, String value2) {
            addCriterion("is_downgrade not between", value1, value2, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeIsNull() {
            addCriterion("product_grade is null");
            return (Criteria) this;
        }

        public Criteria andProductGradeIsNotNull() {
            addCriterion("product_grade is not null");
            return (Criteria) this;
        }

        public Criteria andProductGradeEqualTo(String value) {
            addCriterion("product_grade =", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotEqualTo(String value) {
            addCriterion("product_grade <>", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeGreaterThan(String value) {
            addCriterion("product_grade >", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeGreaterThanOrEqualTo(String value) {
            addCriterion("product_grade >=", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeLessThan(String value) {
            addCriterion("product_grade <", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeLessThanOrEqualTo(String value) {
            addCriterion("product_grade <=", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeLike(String value) {
            addCriterion("product_grade like", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotLike(String value) {
            addCriterion("product_grade not like", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeIn(List<String> values) {
            addCriterion("product_grade in", values, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotIn(List<String> values) {
            addCriterion("product_grade not in", values, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeBetween(String value1, String value2) {
            addCriterion("product_grade between", value1, value2, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotBetween(String value1, String value2) {
            addCriterion("product_grade not between", value1, value2, "productGrade");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIsNull() {
            addCriterion("depot_code is null");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIsNotNull() {
            addCriterion("depot_code is not null");
            return (Criteria) this;
        }

        public Criteria andDepotCodeEqualTo(String value) {
            addCriterion("depot_code =", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotEqualTo(String value) {
            addCriterion("depot_code <>", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeGreaterThan(String value) {
            addCriterion("depot_code >", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeGreaterThanOrEqualTo(String value) {
            addCriterion("depot_code >=", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLessThan(String value) {
            addCriterion("depot_code <", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLessThanOrEqualTo(String value) {
            addCriterion("depot_code <=", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLike(String value) {
            addCriterion("depot_code like", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotLike(String value) {
            addCriterion("depot_code not like", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIn(List<String> values) {
            addCriterion("depot_code in", values, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotIn(List<String> values) {
            addCriterion("depot_code not in", values, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeBetween(String value1, String value2) {
            addCriterion("depot_code between", value1, value2, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotBetween(String value1, String value2) {
            addCriterion("depot_code not between", value1, value2, "depotCode");
            return (Criteria) this;
        }

        public Criteria andTransWayNoIsNull() {
            addCriterion("trans_way_no is null");
            return (Criteria) this;
        }

        public Criteria andTransWayNoIsNotNull() {
            addCriterion("trans_way_no is not null");
            return (Criteria) this;
        }

        public Criteria andTransWayNoEqualTo(String value) {
            addCriterion("trans_way_no =", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoNotEqualTo(String value) {
            addCriterion("trans_way_no <>", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoGreaterThan(String value) {
            addCriterion("trans_way_no >", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoGreaterThanOrEqualTo(String value) {
            addCriterion("trans_way_no >=", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoLessThan(String value) {
            addCriterion("trans_way_no <", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoLessThanOrEqualTo(String value) {
            addCriterion("trans_way_no <=", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoLike(String value) {
            addCriterion("trans_way_no like", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoNotLike(String value) {
            addCriterion("trans_way_no not like", value, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoIn(List<String> values) {
            addCriterion("trans_way_no in", values, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoNotIn(List<String> values) {
            addCriterion("trans_way_no not in", values, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoBetween(String value1, String value2) {
            addCriterion("trans_way_no between", value1, value2, "transWayNo");
            return (Criteria) this;
        }

        public Criteria andTransWayNoNotBetween(String value1, String value2) {
            addCriterion("trans_way_no not between", value1, value2, "transWayNo");
            return (Criteria) this;
        }
    }

    /**
     * framework_contract_goods_info
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title framework_contract_goods_info表的实体类
     * @description framework_contract_goods_info
     * @version 1.0
     * @author may
     * @date 2021-04-06 22:28:45
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
